UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ly4163RMZ9j/likuqfNajAIF4BQ7/3olFEFgncNkfOs=' 
WHERE 
  key_id = 'a4ef4031746d3b463e15dd1986fe3c186f64f32eae1c8d006b2f2ef8f92d6c54' 
  AND (
    token = 'Ly4163RMZ9j/likuqfNajAIF4BQ7/3olFEFgncNkfOs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024