UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W28ZVMPNcwKutKZdZLXWgAynU71iEIUXUdc3gE1xLLQ='
WHERE
key_id = '69a29b92e2e81d0e7b4879c3450c73945e07c2ac130a0250438be27f9396b5c6'
AND (
token = 'W28ZVMPNcwKutKZdZLXWgAynU71iEIUXUdc3gE1xLLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)