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