UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5YHZcPzL9+PS/eDCJkQhu3VF8JX+5bKYs6oa2zpIsi4='
WHERE
key_id = 'd995afbc5f6bceb1146569ba1a15a36c7d743c9bd4a02b53163543f8d907cdc0'
AND (
token = '5YHZcPzL9+PS/eDCJkQhu3VF8JX+5bKYs6oa2zpIsi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)