UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hXqYznaRddTLqcET9V9MdRXINqUM1A5c400lrXZVRc='
WHERE
key_id = 'beb846728d83effa259ec660258ec7a498859c8d575a406ae8d95f9107d42022'
AND (
token = '9hXqYznaRddTLqcET9V9MdRXINqUM1A5c400lrXZVRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)