UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q4gp/gpWC6WtnuDl6KTC7oIWMP2FeANeoSwN5b50c4Q='
WHERE
key_id = 'fe04d0ae23bbe0e8a1c9e19ee0bbae80eaf7989a57c88d8dc8a32792af28d0ae'
AND (
token = 'q4gp/gpWC6WtnuDl6KTC7oIWMP2FeANeoSwN5b50c4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)