UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kGdGPWjIONn+rkk6XwOch/Hw7UNeNTJ00BLcZrOuQ1w='
WHERE
key_id = '7046f74fb27493db0849f33ff1b1d716bb75ccdf6f5906f266bfa6910e9b1b5d'
AND (
token = 'kGdGPWjIONn+rkk6XwOch/Hw7UNeNTJ00BLcZrOuQ1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)