UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hEXjvmYE7DHgG7y65lseL33/aPXW9rW5DnTaAH8hfNw='
WHERE
key_id = '1f8361f36cfc0717181d0a62d0727a1de36d00a9a13ac76f923f951b28e92ef4'
AND (
token = 'hEXjvmYE7DHgG7y65lseL33/aPXW9rW5DnTaAH8hfNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)