UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IZrGUMQXGFP9L9VpDHfXOR4rsm1xGiOYVDveU/zKSeQ='
WHERE
key_id = 'ca16122d0b6a714cf02740f9443ec43a731e494e3509caade0f86ce9ae0b2197'
AND (
token = 'IZrGUMQXGFP9L9VpDHfXOR4rsm1xGiOYVDveU/zKSeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)