UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cap/3Ye3ZwNe0YQzemJGODQxkpZdjJuZoGtgnYMHazU='
WHERE
key_id = 'd5f217dba90013eb1d0fa5abb6284fc72fb9b2cf504f809095d6d89e62a29f16'
AND (
token = 'cap/3Ye3ZwNe0YQzemJGODQxkpZdjJuZoGtgnYMHazU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)