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