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