UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIWU3DjtKRB2VoifOiQzWGgoQiJyMxXbgjJ8mYM3tKU='
WHERE
key_id = '6d0ff433f1cadc90254fa614fbeae8423d5b0bc7a0bd95eed8a865337896a5ac'
AND (
token = 'gIWU3DjtKRB2VoifOiQzWGgoQiJyMxXbgjJ8mYM3tKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)