UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lawffFoatbbiSDGM9R8nEAtKvzN5w4IJe1uAe87OEI8='
WHERE
key_id = '417ad2ae213658863419cdb796fb3aee5b1ffffe418c738f46dd52bbcc220731'
AND (
token = 'lawffFoatbbiSDGM9R8nEAtKvzN5w4IJe1uAe87OEI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)