UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XbH4jbBQ1aI5tSmgkGwXu2pIYjjgVUWv/AHhPh6Uiy8='
WHERE
key_id = 'ebc47abd60e809723d4c59d83b5589e25263d4ce82d7cd6f0639e07c75331a6f'
AND (
token = 'XbH4jbBQ1aI5tSmgkGwXu2pIYjjgVUWv/AHhPh6Uiy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)