UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EhqCL0gFhzpgPO6fGH7PgjtM3+Gv6tvb8w6hSFdnt+4='
WHERE
key_id = 'c7d8540435c807f53323327835ad7e69d4682568cc32fca7b0b591802f125c15'
AND (
token = 'EhqCL0gFhzpgPO6fGH7PgjtM3+Gv6tvb8w6hSFdnt+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)