UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dXphy1HCwm1H9hrvbpRGH9v2m0y9J7//D/av2qT1sG0='
WHERE
key_id = '3e2b56728b9c6cc18e7cc1260127c57f24d9f83bce13310abfc40ff35bfc8d1d'
AND (
token = 'dXphy1HCwm1H9hrvbpRGH9v2m0y9J7//D/av2qT1sG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)