UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jWIRCNCjNca3UFKOnFf4N1jLBFBaGAbonx0FMi/xNzw=' 
WHERE 
  key_id = 'ae100e5cd2c197ee7f323edc0b53d9306aa1695075c9c942c00c234afb5d08cb' 
  AND (
    token = 'jWIRCNCjNca3UFKOnFf4N1jLBFBaGAbonx0FMi/xNzw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034