UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g7nheGv22TptEEjrIVUF3RcheAuCih1qPU3F5QzVBiI='
WHERE
key_id = 'e2c883123181439a9d824b7a9216a4aefd5c4c161b293ee0abd1281d64851b95'
AND (
token = 'g7nheGv22TptEEjrIVUF3RcheAuCih1qPU3F5QzVBiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)