UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z86RB2E9va9+VeG4liMqY9zlCyGuFOaaiYGWkLDQHu0='
WHERE
key_id = '4f7161be3c1a4b7f226548aba01a86e5e8883635d8cb69200ddc3792c55a88f2'
AND (
token = 'Z86RB2E9va9+VeG4liMqY9zlCyGuFOaaiYGWkLDQHu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)