UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P70BCjnhTZIabHzSKiYNV9LsLjXas3WVNwF/sz0Er5k='
WHERE
key_id = '9a7feadd28c4b1b1e7ee25aab3dd5824979b63f5057c3733e84e32387d1e9ef6'
AND (
token = 'P70BCjnhTZIabHzSKiYNV9LsLjXas3WVNwF/sz0Er5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)