UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6uYKhfyY5N3WIsl9ZcuzqXmIwycPOHPv88guBarNUas='
WHERE
key_id = 'cd0a248892522fc7f317d5cb413b13efadb6c7f0fd1f4fb7c98f8ab50f127b02'
AND (
token = '6uYKhfyY5N3WIsl9ZcuzqXmIwycPOHPv88guBarNUas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)