UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ir2RZrIhfiwAuHgl26j/WE8Hu3GGkbWZlIPdbJhqG24='
WHERE
key_id = 'e81e25b818d72e5aab356a1bd18a99c24f82022d8fe683ac24e3d08b4ca2df25'
AND (
token = 'ir2RZrIhfiwAuHgl26j/WE8Hu3GGkbWZlIPdbJhqG24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)