UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CCG01+0TQK7R0u1HudvMQDYUVBmOnhf9CSwVUqmMrY='
WHERE
key_id = '2fb7e96f234547ff66bf4862171696ee738f1b8c05e89763af2b704bd54e54e5'
AND (
token = '8CCG01+0TQK7R0u1HudvMQDYUVBmOnhf9CSwVUqmMrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)