UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8WhllRWt0PDq7iwlNLSQSyHvn9YovspSLfQ9koFaBI='
WHERE
key_id = '643f783ded2e40a8c1fb556ed5d055b084f04349e75328ded7ff709caf6b5295'
AND (
token = 'X8WhllRWt0PDq7iwlNLSQSyHvn9YovspSLfQ9koFaBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)