UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3XoyR/cuwYcVMpIP70PdS/mYz+mYd4hXin08PQThErY=' 
WHERE 
  key_id = '95f4bc4d89320f26d500463e0c836f1c0ef02f86e3ea91216b35bdd358350aa1' 
  AND (
    token = '3XoyR/cuwYcVMpIP70PdS/mYz+mYd4hXin08PQThErY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048