UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xB+Qub2kjgR/17Cnc2A9Or4yKYItBfjnCCg1w5UaQ7c='
WHERE
key_id = 'bf4f496737cfa040ab88f2926d5c5f6ccfa86a3813e085816fb7cb85d4f88354'
AND (
token = 'xB+Qub2kjgR/17Cnc2A9Or4yKYItBfjnCCg1w5UaQ7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)