UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGnAHRru0ymo1djASUB+uPaAGFTRhcykpEZF+lXir2I='
WHERE
key_id = 'cca20336c27e215fa8135270d97ec389271455efc4a2f05b3772b5add3ab7146'
AND (
token = 'XGnAHRru0ymo1djASUB+uPaAGFTRhcykpEZF+lXir2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)