UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oh3TRDnGSpkRZDKiNeJiuIuFopb5lpAgq4wRYVclEU4=' 
WHERE 
  key_id = '95d0fd341e7b6976d26e80c4b087d725445e39d58af0a2a44216582484f53ac4' 
  AND (
    token = 'oh3TRDnGSpkRZDKiNeJiuIuFopb5lpAgq4wRYVclEU4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021