UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nbOt1pykFaGFbL9CmzkB6bheHrWTmE1mKDfESC/5QEU='
WHERE
key_id = 'd85497ef1ec533dc12fd4f9970e74daf4a3f4744223e74e1d1133fd54bb56ae0'
AND (
token = 'nbOt1pykFaGFbL9CmzkB6bheHrWTmE1mKDfESC/5QEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)