UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1znoePxgwRudYw2hbXjDauZIeVl/oGg89SaWropi9A0='
WHERE
key_id = 'f54e5f4dc13bce3a17665a2a987384095b6b50072a1994a21c18c021d3cda9e7'
AND (
token = '1znoePxgwRudYw2hbXjDauZIeVl/oGg89SaWropi9A0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)