UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ch9s9OgSgpzWxV9mSk38AirdtBZRZrxGI1udUIvsWVQ='
WHERE
key_id = '2545501351b581b3bb2a452fee4dfb1a7aaceb1687f8154daa002ee4f54e5ca3'
AND (
token = 'ch9s9OgSgpzWxV9mSk38AirdtBZRZrxGI1udUIvsWVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)