UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '41QCW0CQ1r+I/TbWXcXfwDm9WXh/G6pk0w/DRwNrgIU='
WHERE
key_id = '9a170e9aa5384ed24ac8ae6cb1ac6f3c8ae2e3211a4f849b9387c9e1c03fccb4'
AND (
token = '41QCW0CQ1r+I/TbWXcXfwDm9WXh/G6pk0w/DRwNrgIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)