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